select * from products where pro_name like '%quinceanera%bra%' or pro_des like '%quinceanera%bra%'union all select * from products where (pro_name like '%quinceanera%' or pro_des like '%quinceanera%') or(pro_name like '%bra%' or pro_des like '%bra%') and (pro_name not like '%quinceanera%bra%' or pro_des not like '%quinceanera%bra%')

Hand Made Flowers and Beading Strapless Blue and White Quinceanera Dress

Beaded Sweetheart and Waistline Tulle Quinceanera Dress in Multi-color

Beading Sweetheart Embroidery Taffeta Quinceanera Dress in Purple

White and Eggplant Purple Appliques Quinceanera Dress with Pick-ups

Sweetheart Appliques Sweet Sixteen Quinceanera Dresses in White and Purple

Multi-color Beading Sweetheart Quinceanera Dress with Organza Ruffles

Banding and Ruche Red Quinceanera Dress With Ruffles and Jacket

Appliques and Beading Baby Blue Taffeta Quinceanera Dress with Layers

Appliques and Beading Tulle Dresses For Quinceaneras in Hot Pink and White

Layers and Hand Made Flowers Strapless Dresses 15 in Teal and Yellow

Hand Made Flowers Strapless Fuchsia Organza Appliques Dresses Of 15

2013 Lavender Appliques Quinceanera Dress with Ruche and Beading

Appliques and Sash Strapless Tulle Quinceanera Dress in Multi-color

Hot Pink And White Quinceanera Dress with Ruching and Appliques

Yellow Green Sweetheart Appliques Quinceanera Dress with Ruffles

Hot Pink Beaded and Ruffles Discount 15 Dresses with Brush Train

Brush Train Organza Beading and Ruffles Quinceanea Dress in Blue

Purple Ball Gown Embroidery Quinceanera Dress with White Appliques

Baby Blue Ball Gown for Beading and Embroidery Quinceanera Dress

Embroidery and Sequins Teal Quinceanera Dress with Special Fabric

Black Boning Details Hot Pink Qunceanera Dress with Beaded Decor

Hot Pink Quinceanera Dress Hand Made Flowers With Embroidery

Appliques Layered Ruffles Colorful Dresses 15 Wear For Graduation

Beaded and Embroidery Decorated Black and Wine Red Quinceanera Dress

Ruffled Layers Decorate for Rose Pink and Orange Quinceanera Dress

Long Sleeves and Appliques Decorated Quinceanera Dress in Fushsia

Handle Flower and Corset Front Decorated Colorful Quinceanera Dress

Watermelon and Black Sweetheart Ruffles 2013 Dresses for a Quince

Stylish Multi-color 2014 Hilary Swank Quinceanera Dress with Appliques and Ruffles

Leopard Top and Pieces Ruffles 15 Dresses in Burgundy and Black